<?php

require_once dirname(dirname(__FILE__)) . '/config/config.php';
require_once dirname(dirname(__FILE__)) . '/config/connection.php';

/**
 * User: Viet Anh
 * Date: 13/06/2014
 * Time: 00:47
 */
class dao_roulette_map
{
    public function get_all() {
        $db = new connection();
        $con = $db->open_connect();

        $query = "SELECT * FROM tbl_roulette_map ";
        $result = mysqli_query($con, $query)
        or die("Query fail: " . mysqli_error());

        $list = array();
        while ($row = mysqli_fetch_array($result)) {
            array_push($list, $row);
        }
        $db->close_connect();
        return $list;
    }
    
    public function save($id, $number, $color, $column) {
        $db = new connection();
        $con = $db->open_connect();

        if ($id == 0) {
            $query = "INSERT INTO tbl_roulette_map(number, color, column) VALUES (
                '" . $number . "','" . $color . "','" . $column . "')";
        } else {
            $query = "UPDATE tbl_roulette_map SET "
                    . "number = '" . $number . "',"
                    . "color = '" . $color . "',"
                    . "column = '" . $column . "' "
                    . "WHERE id = " . $id;
        }
        mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

        $db->close_connect();
        return TRUE;
    }
    
    public function get_by_id($id) {
        $db = new connection();
        $con = $db->open_connect();

        $query = "SELECT * FROM tbl_roulette_map WHERE id = " . $id;
        $result = mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

        $row = mysqli_fetch_array($result);

        $db->close_connect();
        return $row;
    }
    
    public function delete($id) {
        $db = new connection();
        $con = $db->open_connect();

        $query = "DELETE FROM tbl_roulette_map WHERE id = " . $id;
        mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

        $db->close_connect();
        return TRUE;
    }
}